home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI132.ASC
< prev
next >
Wrap
Text File
|
1993-03-31
|
5KB
|
199 lines
PRODUCT : Paradox NUMBER : 132
VERSION : All
OS : DOS
DATE : March 31, 1993 PAGE : 1/3
TITLE : Useful Picture Statements
A picture is a powerful and flexible tool for controlling what a
user can type into a field during data entry. You can use
pictures to shape and limit what the user can type into a field
and make data entry easier by filling in required or default
values automatically.
To define a picture for a field, edit the table. Choose Modify |
Edit and enter in the name of the table. Next, press <F10> for
the Edit menu, and use the following menu choices: Valcheck |
Define | Picture. At this point, enter in the picture statement
for the field. This document contains a list of useful picture
statements.
Pictures can also be used with the PAL Accept command. See the
PAL Reference Guide for a discussion of the Accept command (for
version 3.5 and earlier, refer to Chapter 20 of the PAL User's
Guide).
Definition of Picture Symbols:
Match characters:
# Accepts ONLY a numeric digit
? Accepts ONLY a letter EITHER upper or lower
@ Accepts ANY character
& Accepts ONLY a letter, converts it to upper case
! Accepts ANY character, converts letters to upper case
Any other character typed that is not defined as a
match character or a special character is taken
literally.
Special characters:
; The next character is literal, not a picture-string
character
* The next character can be repeated any number of times.
Or, specify how many occurrences of the next letter to
require.
[] Characters inside brackets are optional
{} Characters inside braces are grouped
, Alternative values
PRODUCT : Paradox NUMBER : 132
VERSION : All
OS : DOS
DATE : March 31, 1993 PAGE : 2/3
TITLE : Useful Picture Statements
Useful Picture Statements:
ZIP Code with optional last four digits #####[{-}####]
SSN with automatic fill in of dashes ###-##-####
SSN with fill in of dashes using spacebar or - ###{-}##{-}####
Allow letters only - Spaces NOT allowed *?
Allow letters only and capitalize the first one, spaces not
allowed:
&*?
Allow letters only - capitalize all letters *&
Capitalize the first letter only of the first word
!*@
Capitalize the first letter of every word (I) *[![*?][* ]]
Capitalize the first letter of every word (II) !*[ * !,@]
Capitalize the first letter of every word (III)
*{ ,.}!*{{ ,.}*{ ,.}!,@}
Capitalize the first letter of every word (IV)
*[[*#[ ]]![*?][@][ ]]
Capitalize the first letter of every word after a comma, blank
space or parenthesis:
!*[{ ,.,(,;,}*{ ,.,(,;,}!,@]
Simulate a Time data type with format of HH:MM:SS:
{0#,1#,2{0,1,2,3}}:{0,1,2,3,4,5}#:{0,1,2,3,4,5}#
Simulate a Time data type with form of HH:MM and :SS optional:
{0#,1#,2{0,1,2,3}}:{0,1,2,3,4,5}#[:{0,1,2,3,4,5}#]
Simulate a Time data type with form of HH:MM AM or HH:MM PM
{1{:,{0,1,2}:},{2,3,4,5,6,7,8,9}:}{0,1,2,3,4,5}# {AM,PM}
Phone number w/ automatic fill in of dashes
###-####
PRODUCT : Paradox NUMBER : 132
VERSION : All
OS : DOS
DATE : March 31, 1993 PAGE : 3/3
TITLE : Useful Picture Statements
Phone number w/ automatic dashes area code optional
[(###)]###-####
Phone number w/1-800 optional
[{1-800-,(###)}]###-####
Date - automatic fill in of slashes
{##/##/##,#/##/##}
Date - forces 01 for day w/auto fill in of slashes
{##/01/##,#/01/##}
Date - forces 01 for day w/system clock year
{##/01/[##],#/01/[##]}
Automatic entering from a list based on partial keystrokes of
word.
{Paradox,Quattro,dBASE}
Allows entry of Miss, Ms., Mr., or Mrs.
M{iss,s.,r{.,s.}}
Allows additional entry of Dr., Doctor, Father, Miss, Mrs., Mr.,
Mr. & Mrs., Ms., Msgr., Pastor, and Reverend:
{D{r.,octor},Father,M{iss,r{s.,.[ ;& Mrs.]},s{.,gr.}},Pastor,Reverend}
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.